home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vprobes.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
26 lines
CREATE OR REPLACE VIEW vprobes AS
SELECT
CASHBOX.CASHBOX_GLID, CONVERT.FAREBOX_GLID,
CONVERT.CONVERSION_NUM, CONVERT.BEG_DET_SEQ, CONVERT.END_DET_SEQ,
CONVERT.CONVERSION_DATE,PRO.PDATE, BUS.BUS_ID,
CURSTATE.DET_SEQ_NUM, CURSTATE.CURRENT_CASHBOX_ID, CURSTATE.ROUTE, CURSTATE.RUN, CURSTATE.TRIP,
CURSTATE.REPORTING_FLAG, OPERATOR_CONTEXT.USER_ID,
CASHBOX.CB_SERNUM, CURSTATE.PROBE_CONTEXT_ID, CURSTATE.OP_CONTEXT_ID,
CURSTATE.DRIVER_CONTEXT_ID, CURSTATE.FARE_CONTEXT_ID
FROM
CASHBOX CASHBOX,
CONVERT CONVERT,
PROBEHIST PRO,
CURSTATE CURSTATE,
OPERATOR_CONTEXT,
FAREBOX,
BUS
WHERE /*TRUNC(pro.pdate) BETWEEN '23-FEB-2000' AND '25-FEB-2000' AND*/
PRO.PDATE >= CONVERT.BEG_DATE AND
( CONVERT.FAREBOX_GLID=PRO.FAREBOX_GLID ) AND
( CONVERT.CONVERSION_NUM=PRO.CONVERSION_NUM ) AND
(CURSTATE.DET_SEQ_NUM BETWEEN CONVERT.BEG_DET_SEQ AND CONVERT.END_DET_SEQ ) AND
( PRO.FAREBOX_GLID=CURSTATE.FAREBOX_GLID ) AND
( CURSTATE.CURRENT_CASHBOX_ID=CASHBOX.CB_SERNUM ) AND CURSTATE.REPORTING_FLAG = 1 AND
CURSTATE.OP_CONTEXT_ID = OPERATOR_CONTEXT.OP_CONTEXT_ID AND FAREBOX.GLID = PRO.FAREBOX_GLID AND
BUS.GLID = FAREBOX.LOCATION;